sqlite COUNT in flex returning [object Object]
Posted
by Adam
on Stack Overflow
See other posts from Stack Overflow
or by Adam
Published on 2010-04-16T15:29:06Z
Indexed on
2010/04/16
15:33 UTC
Read the original article
Hit count: 170
I'm sure this is an easy questions and I'm just doing something stupid but I'm really new to all this code.
I'm trying to run a sqlite query in flex to count the total number of records
I believe its working fine but I just can't figure out how to display the results - all I get back is [object Object].
private function overviewOne():void{
var stmt:SQLStatement = new SQLStatement();
stmt.sqlConnection = sqlConn;
stmt.text = "SELECT COUNT(user_id) FROM tbl_user WHERE status_status ='Away'";
stmt.execute();
var result:SQLResult = stmt.getResult();
acoverviewOne = new Array(result.data);
trace (result.data[0]);
}
© Stack Overflow or respective owner